<%@ page language="java" contentType="application/vnd.ms-excel;charset=UTF-8"  pageEncoding="UTF-8"%>
<%@ taglib prefix="s" uri="/WEB-INF/struts-tags.tld"%>
<%
   String sortType=request.getParameter("conds.sortType");
   System.out.println("sortType="+sortType);
   String fileName="需求单报表.xls";

   fileName=java.net.URLEncoder.encode(fileName, "UTF-8");
	response.setHeader("Content-Disposition",
			"attachment; filename="+fileName);
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
		<meta http-equiv="pragma" content="no-cache" />
		<meta http-equiv="Content-Type" content="application/vnd.ms-excel; charset=UTF-8">
<title>报表</title>
</head>
	<body leftmargin="0" topmargin="0">
							<table id="table1" name="table1" width="98%" border="1" cellspacing="0" cellpadding="7" align="center">
								<tr>
									<td bgcolor="9AC2EB" width="*">
									<div align="center">需求名称</div>
									</td>
									<td bgcolor="9AC2EB" width="9%">
									<div align="center">重要性
									</div>
									<td bgcolor="9AC2EB" width="11%">
									<div align="center">需求类别
									</div>
									</td>
									<td bgcolor="9AC2EB" width="11%">
									<div align="center">需求部门</div>
									</td>
									<td bgcolor="9AC2EB" width="9%">
									<div align="center">需求人</div>
									</td>
									<td bgcolor="9AC2EB" width="9%">
									<div align="center">产品部门</div>
									</td>
									<td bgcolor="9AC2EB" width="9%">
									<div align="center">产品经理</div>
									</td>
									<td bgcolor="9AC2EB" width="9%">
									<div align="center">提出时间</div>
									</td>
									<td bgcolor="9AC2EB" width="9%">
									<div align="center">关联产品</div>
									</td>
									<s:iterator value="processConfigDetails">
									<td bgcolor="9AC2EB" width="45">
										<div align="center"><s:property value="name" /></div>
									</td>
									</s:iterator>
								</tr>
								
							<s:iterator value="businessRequests">
								<tr>                      
									<td>
										<div align="center"><s:property value="name" /></div>
									</td>
									<td>
										<div align="center"><s:property value="importance" /></div>
									</td>
									<td>
										<div align="center"><s:property value="type" /></div>
									</td>
									<td>
										<div align="center"><s:property value="startDept" /></div>
									</td>
									<td>
										<div align="center"><s:property value="startPerson" /></div>
									</td>
									<td>
										<div align="center"><s:property value="prodDept.fullName" /></div>
									</td>
									<td>
										<div align="center"><s:property value="prodPerson.name" /></div>
									</td>
									<td>
										<div align="center"><s:date name="advanTime" format="yyyy-MM-dd"/></div>
									</td>
									<td>
										<div align="center"><s:property value="" /></div>
									</td>
									<s:if test="processConfigDetails!=null">
									<td colspan="${num}">
										<div align="left">
										<img src="<s:url value='http://hdzx.fjtelecom.com/' escapeAmp='false'/>images/new/jiantou.gif" width="${percent*num*45/100}" height="20"/></div>
									<s:property value="currUser" />:<br>
							<s:iterator value="reqProgresses" status="rp">
								<s:property value="#rp.getIndex()+1"/>.<s:property value="reqProg"/>
								&nbsp;完成<s:property value="percent"/>%
								【<s:date name="createTime" format="yyyy\MM\dd"/>】。<br>
							</s:iterator>
									</td>
									</s:if>
									
									
								</tr>
							</s:iterator>

							
							
							</table>

</body>
<script>

</script>
</html>
